package com.rc.saas.tenant.model.shop;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ShopOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ShopOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andShopOrderIdIsNull() {
            addCriterion("shop_order_id is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdIsNotNull() {
            addCriterion("shop_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdEqualTo(Long value) {
            addCriterion("shop_order_id =", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdNotEqualTo(Long value) {
            addCriterion("shop_order_id <>", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdGreaterThan(Long value) {
            addCriterion("shop_order_id >", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdGreaterThanOrEqualTo(Long value) {
            addCriterion("shop_order_id >=", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdLessThan(Long value) {
            addCriterion("shop_order_id <", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdLessThanOrEqualTo(Long value) {
            addCriterion("shop_order_id <=", value, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdIn(List<Long> values) {
            addCriterion("shop_order_id in", values, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdNotIn(List<Long> values) {
            addCriterion("shop_order_id not in", values, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdBetween(Long value1, Long value2) {
            addCriterion("shop_order_id between", value1, value2, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andShopOrderIdNotBetween(Long value1, Long value2) {
            addCriterion("shop_order_id not between", value1, value2, "shopOrderId");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIsNull() {
            addCriterion("tenant_code is null");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIsNotNull() {
            addCriterion("tenant_code is not null");
            return (Criteria) this;
        }

        public Criteria andTenantCodeEqualTo(String value) {
            addCriterion("tenant_code =", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotEqualTo(String value) {
            addCriterion("tenant_code <>", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeGreaterThan(String value) {
            addCriterion("tenant_code >", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeGreaterThanOrEqualTo(String value) {
            addCriterion("tenant_code >=", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLessThan(String value) {
            addCriterion("tenant_code <", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLessThanOrEqualTo(String value) {
            addCriterion("tenant_code <=", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLike(String value) {
            addCriterion("tenant_code like", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotLike(String value) {
            addCriterion("tenant_code not like", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIn(List<String> values) {
            addCriterion("tenant_code in", values, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotIn(List<String> values) {
            addCriterion("tenant_code not in", values, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeBetween(String value1, String value2) {
            addCriterion("tenant_code between", value1, value2, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotBetween(String value1, String value2) {
            addCriterion("tenant_code not between", value1, value2, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumIsNull() {
            addCriterion("shop_order_num is null");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumIsNotNull() {
            addCriterion("shop_order_num is not null");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumEqualTo(String value) {
            addCriterion("shop_order_num =", value, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumNotEqualTo(String value) {
            addCriterion("shop_order_num <>", value, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumGreaterThan(String value) {
            addCriterion("shop_order_num >", value, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumGreaterThanOrEqualTo(String value) {
            addCriterion("shop_order_num >=", value, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumLessThan(String value) {
            addCriterion("shop_order_num <", value, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumLessThanOrEqualTo(String value) {
            addCriterion("shop_order_num <=", value, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumLike(String value) {
            addCriterion("shop_order_num like", value, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumNotLike(String value) {
            addCriterion("shop_order_num not like", value, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumIn(List<String> values) {
            addCriterion("shop_order_num in", values, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumNotIn(List<String> values) {
            addCriterion("shop_order_num not in", values, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumBetween(String value1, String value2) {
            addCriterion("shop_order_num between", value1, value2, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andShopOrderNumNotBetween(String value1, String value2) {
            addCriterion("shop_order_num not between", value1, value2, "shopOrderNum");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("member_id is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("member_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(Long value) {
            addCriterion("member_id =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(Long value) {
            addCriterion("member_id <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(Long value) {
            addCriterion("member_id >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(Long value) {
            addCriterion("member_id >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(Long value) {
            addCriterion("member_id <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(Long value) {
            addCriterion("member_id <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<Long> values) {
            addCriterion("member_id in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<Long> values) {
            addCriterion("member_id not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(Long value1, Long value2) {
            addCriterion("member_id between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(Long value1, Long value2) {
            addCriterion("member_id not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andSaleTypeIsNull() {
            addCriterion("sale_type is null");
            return (Criteria) this;
        }

        public Criteria andSaleTypeIsNotNull() {
            addCriterion("sale_type is not null");
            return (Criteria) this;
        }

        public Criteria andSaleTypeEqualTo(String value) {
            addCriterion("sale_type =", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeNotEqualTo(String value) {
            addCriterion("sale_type <>", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeGreaterThan(String value) {
            addCriterion("sale_type >", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeGreaterThanOrEqualTo(String value) {
            addCriterion("sale_type >=", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeLessThan(String value) {
            addCriterion("sale_type <", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeLessThanOrEqualTo(String value) {
            addCriterion("sale_type <=", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeLike(String value) {
            addCriterion("sale_type like", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeNotLike(String value) {
            addCriterion("sale_type not like", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeIn(List<String> values) {
            addCriterion("sale_type in", values, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeNotIn(List<String> values) {
            addCriterion("sale_type not in", values, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeBetween(String value1, String value2) {
            addCriterion("sale_type between", value1, value2, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeNotBetween(String value1, String value2) {
            addCriterion("sale_type not between", value1, value2, "saleType");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIsNull() {
            addCriterion("goods_amount is null");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIsNotNull() {
            addCriterion("goods_amount is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountEqualTo(BigDecimal value) {
            addCriterion("goods_amount =", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotEqualTo(BigDecimal value) {
            addCriterion("goods_amount <>", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountGreaterThan(BigDecimal value) {
            addCriterion("goods_amount >", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_amount >=", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountLessThan(BigDecimal value) {
            addCriterion("goods_amount <", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_amount <=", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIn(List<BigDecimal> values) {
            addCriterion("goods_amount in", values, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotIn(List<BigDecimal> values) {
            addCriterion("goods_amount not in", values, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_amount between", value1, value2, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_amount not between", value1, value2, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountIsNull() {
            addCriterion("discount_amount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountIsNotNull() {
            addCriterion("discount_amount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountEqualTo(BigDecimal value) {
            addCriterion("discount_amount =", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountNotEqualTo(BigDecimal value) {
            addCriterion("discount_amount <>", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountGreaterThan(BigDecimal value) {
            addCriterion("discount_amount >", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount_amount >=", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountLessThan(BigDecimal value) {
            addCriterion("discount_amount <", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount_amount <=", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountIn(List<BigDecimal> values) {
            addCriterion("discount_amount in", values, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountNotIn(List<BigDecimal> values) {
            addCriterion("discount_amount not in", values, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount_amount between", value1, value2, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount_amount not between", value1, value2, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountIsNull() {
            addCriterion("pay_amount is null");
            return (Criteria) this;
        }

        public Criteria andPayAmountIsNotNull() {
            addCriterion("pay_amount is not null");
            return (Criteria) this;
        }

        public Criteria andPayAmountEqualTo(BigDecimal value) {
            addCriterion("pay_amount =", value, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountNotEqualTo(BigDecimal value) {
            addCriterion("pay_amount <>", value, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountGreaterThan(BigDecimal value) {
            addCriterion("pay_amount >", value, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_amount >=", value, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountLessThan(BigDecimal value) {
            addCriterion("pay_amount <", value, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_amount <=", value, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountIn(List<BigDecimal> values) {
            addCriterion("pay_amount in", values, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountNotIn(List<BigDecimal> values) {
            addCriterion("pay_amount not in", values, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_amount between", value1, value2, "payAmount");
            return (Criteria) this;
        }

        public Criteria andPayAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_amount not between", value1, value2, "payAmount");
            return (Criteria) this;
        }

        public Criteria andUsePointIsNull() {
            addCriterion("use_point is null");
            return (Criteria) this;
        }

        public Criteria andUsePointIsNotNull() {
            addCriterion("use_point is not null");
            return (Criteria) this;
        }

        public Criteria andUsePointEqualTo(Integer value) {
            addCriterion("use_point =", value, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointNotEqualTo(Integer value) {
            addCriterion("use_point <>", value, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointGreaterThan(Integer value) {
            addCriterion("use_point >", value, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointGreaterThanOrEqualTo(Integer value) {
            addCriterion("use_point >=", value, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointLessThan(Integer value) {
            addCriterion("use_point <", value, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointLessThanOrEqualTo(Integer value) {
            addCriterion("use_point <=", value, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointIn(List<Integer> values) {
            addCriterion("use_point in", values, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointNotIn(List<Integer> values) {
            addCriterion("use_point not in", values, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointBetween(Integer value1, Integer value2) {
            addCriterion("use_point between", value1, value2, "usePoint");
            return (Criteria) this;
        }

        public Criteria andUsePointNotBetween(Integer value1, Integer value2) {
            addCriterion("use_point not between", value1, value2, "usePoint");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNull() {
            addCriterion("payment_type is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNotNull() {
            addCriterion("payment_type is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeEqualTo(String value) {
            addCriterion("payment_type =", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotEqualTo(String value) {
            addCriterion("payment_type <>", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThan(String value) {
            addCriterion("payment_type >", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThanOrEqualTo(String value) {
            addCriterion("payment_type >=", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThan(String value) {
            addCriterion("payment_type <", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThanOrEqualTo(String value) {
            addCriterion("payment_type <=", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLike(String value) {
            addCriterion("payment_type like", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotLike(String value) {
            addCriterion("payment_type not like", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIn(List<String> values) {
            addCriterion("payment_type in", values, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotIn(List<String> values) {
            addCriterion("payment_type not in", values, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeBetween(String value1, String value2) {
            addCriterion("payment_type between", value1, value2, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotBetween(String value1, String value2) {
            addCriterion("payment_type not between", value1, value2, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNull() {
            addCriterion("payment_time is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNotNull() {
            addCriterion("payment_time is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualTo(Date value) {
            addCriterion("payment_time =", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualTo(Date value) {
            addCriterion("payment_time <>", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThan(Date value) {
            addCriterion("payment_time >", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("payment_time >=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThan(Date value) {
            addCriterion("payment_time <", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualTo(Date value) {
            addCriterion("payment_time <=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIn(List<Date> values) {
            addCriterion("payment_time in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotIn(List<Date> values) {
            addCriterion("payment_time not in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeBetween(Date value1, Date value2) {
            addCriterion("payment_time between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotBetween(Date value1, Date value2) {
            addCriterion("payment_time not between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeIsNull() {
            addCriterion("deliver_time is null");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeIsNotNull() {
            addCriterion("deliver_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeEqualTo(Date value) {
            addCriterion("deliver_time =", value, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeNotEqualTo(Date value) {
            addCriterion("deliver_time <>", value, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeGreaterThan(Date value) {
            addCriterion("deliver_time >", value, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("deliver_time >=", value, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeLessThan(Date value) {
            addCriterion("deliver_time <", value, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeLessThanOrEqualTo(Date value) {
            addCriterion("deliver_time <=", value, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeIn(List<Date> values) {
            addCriterion("deliver_time in", values, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeNotIn(List<Date> values) {
            addCriterion("deliver_time not in", values, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeBetween(Date value1, Date value2) {
            addCriterion("deliver_time between", value1, value2, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andDeliverTimeNotBetween(Date value1, Date value2) {
            addCriterion("deliver_time not between", value1, value2, "deliverTime");
            return (Criteria) this;
        }

        public Criteria andExpressIdIsNull() {
            addCriterion("express_id is null");
            return (Criteria) this;
        }

        public Criteria andExpressIdIsNotNull() {
            addCriterion("express_id is not null");
            return (Criteria) this;
        }

        public Criteria andExpressIdEqualTo(Long value) {
            addCriterion("express_id =", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdNotEqualTo(Long value) {
            addCriterion("express_id <>", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdGreaterThan(Long value) {
            addCriterion("express_id >", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdGreaterThanOrEqualTo(Long value) {
            addCriterion("express_id >=", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdLessThan(Long value) {
            addCriterion("express_id <", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdLessThanOrEqualTo(Long value) {
            addCriterion("express_id <=", value, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdIn(List<Long> values) {
            addCriterion("express_id in", values, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdNotIn(List<Long> values) {
            addCriterion("express_id not in", values, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdBetween(Long value1, Long value2) {
            addCriterion("express_id between", value1, value2, "expressId");
            return (Criteria) this;
        }

        public Criteria andExpressIdNotBetween(Long value1, Long value2) {
            addCriterion("express_id not between", value1, value2, "expressId");
            return (Criteria) this;
        }

        public Criteria andShippingNoIsNull() {
            addCriterion("shipping_no is null");
            return (Criteria) this;
        }

        public Criteria andShippingNoIsNotNull() {
            addCriterion("shipping_no is not null");
            return (Criteria) this;
        }

        public Criteria andShippingNoEqualTo(String value) {
            addCriterion("shipping_no =", value, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoNotEqualTo(String value) {
            addCriterion("shipping_no <>", value, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoGreaterThan(String value) {
            addCriterion("shipping_no >", value, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_no >=", value, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoLessThan(String value) {
            addCriterion("shipping_no <", value, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoLessThanOrEqualTo(String value) {
            addCriterion("shipping_no <=", value, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoLike(String value) {
            addCriterion("shipping_no like", value, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoNotLike(String value) {
            addCriterion("shipping_no not like", value, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoIn(List<String> values) {
            addCriterion("shipping_no in", values, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoNotIn(List<String> values) {
            addCriterion("shipping_no not in", values, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoBetween(String value1, String value2) {
            addCriterion("shipping_no between", value1, value2, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andShippingNoNotBetween(String value1, String value2) {
            addCriterion("shipping_no not between", value1, value2, "shippingNo");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressIsNull() {
            addCriterion("deliver_express is null");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressIsNotNull() {
            addCriterion("deliver_express is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressEqualTo(String value) {
            addCriterion("deliver_express =", value, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressNotEqualTo(String value) {
            addCriterion("deliver_express <>", value, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressGreaterThan(String value) {
            addCriterion("deliver_express >", value, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressGreaterThanOrEqualTo(String value) {
            addCriterion("deliver_express >=", value, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressLessThan(String value) {
            addCriterion("deliver_express <", value, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressLessThanOrEqualTo(String value) {
            addCriterion("deliver_express <=", value, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressLike(String value) {
            addCriterion("deliver_express like", value, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressNotLike(String value) {
            addCriterion("deliver_express not like", value, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressIn(List<String> values) {
            addCriterion("deliver_express in", values, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressNotIn(List<String> values) {
            addCriterion("deliver_express not in", values, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressBetween(String value1, String value2) {
            addCriterion("deliver_express between", value1, value2, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andDeliverExpressNotBetween(String value1, String value2) {
            addCriterion("deliver_express not between", value1, value2, "deliverExpress");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdIsNull() {
            addCriterion("shipping_province_id is null");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdIsNotNull() {
            addCriterion("shipping_province_id is not null");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdEqualTo(String value) {
            addCriterion("shipping_province_id =", value, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdNotEqualTo(String value) {
            addCriterion("shipping_province_id <>", value, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdGreaterThan(String value) {
            addCriterion("shipping_province_id >", value, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_province_id >=", value, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdLessThan(String value) {
            addCriterion("shipping_province_id <", value, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdLessThanOrEqualTo(String value) {
            addCriterion("shipping_province_id <=", value, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdLike(String value) {
            addCriterion("shipping_province_id like", value, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdNotLike(String value) {
            addCriterion("shipping_province_id not like", value, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdIn(List<String> values) {
            addCriterion("shipping_province_id in", values, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdNotIn(List<String> values) {
            addCriterion("shipping_province_id not in", values, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdBetween(String value1, String value2) {
            addCriterion("shipping_province_id between", value1, value2, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingProvinceIdNotBetween(String value1, String value2) {
            addCriterion("shipping_province_id not between", value1, value2, "shippingProvinceId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdIsNull() {
            addCriterion("shipping_city_id is null");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdIsNotNull() {
            addCriterion("shipping_city_id is not null");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdEqualTo(String value) {
            addCriterion("shipping_city_id =", value, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdNotEqualTo(String value) {
            addCriterion("shipping_city_id <>", value, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdGreaterThan(String value) {
            addCriterion("shipping_city_id >", value, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_city_id >=", value, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdLessThan(String value) {
            addCriterion("shipping_city_id <", value, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdLessThanOrEqualTo(String value) {
            addCriterion("shipping_city_id <=", value, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdLike(String value) {
            addCriterion("shipping_city_id like", value, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdNotLike(String value) {
            addCriterion("shipping_city_id not like", value, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdIn(List<String> values) {
            addCriterion("shipping_city_id in", values, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdNotIn(List<String> values) {
            addCriterion("shipping_city_id not in", values, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdBetween(String value1, String value2) {
            addCriterion("shipping_city_id between", value1, value2, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingCityIdNotBetween(String value1, String value2) {
            addCriterion("shipping_city_id not between", value1, value2, "shippingCityId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdIsNull() {
            addCriterion("shipping_area_id is null");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdIsNotNull() {
            addCriterion("shipping_area_id is not null");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdEqualTo(String value) {
            addCriterion("shipping_area_id =", value, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdNotEqualTo(String value) {
            addCriterion("shipping_area_id <>", value, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdGreaterThan(String value) {
            addCriterion("shipping_area_id >", value, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_area_id >=", value, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdLessThan(String value) {
            addCriterion("shipping_area_id <", value, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdLessThanOrEqualTo(String value) {
            addCriterion("shipping_area_id <=", value, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdLike(String value) {
            addCriterion("shipping_area_id like", value, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdNotLike(String value) {
            addCriterion("shipping_area_id not like", value, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdIn(List<String> values) {
            addCriterion("shipping_area_id in", values, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdNotIn(List<String> values) {
            addCriterion("shipping_area_id not in", values, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdBetween(String value1, String value2) {
            addCriterion("shipping_area_id between", value1, value2, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAreaIdNotBetween(String value1, String value2) {
            addCriterion("shipping_area_id not between", value1, value2, "shippingAreaId");
            return (Criteria) this;
        }

        public Criteria andShippingAddressIsNull() {
            addCriterion("shipping_address is null");
            return (Criteria) this;
        }

        public Criteria andShippingAddressIsNotNull() {
            addCriterion("shipping_address is not null");
            return (Criteria) this;
        }

        public Criteria andShippingAddressEqualTo(String value) {
            addCriterion("shipping_address =", value, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressNotEqualTo(String value) {
            addCriterion("shipping_address <>", value, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressGreaterThan(String value) {
            addCriterion("shipping_address >", value, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_address >=", value, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressLessThan(String value) {
            addCriterion("shipping_address <", value, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressLessThanOrEqualTo(String value) {
            addCriterion("shipping_address <=", value, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressLike(String value) {
            addCriterion("shipping_address like", value, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressNotLike(String value) {
            addCriterion("shipping_address not like", value, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressIn(List<String> values) {
            addCriterion("shipping_address in", values, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressNotIn(List<String> values) {
            addCriterion("shipping_address not in", values, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressBetween(String value1, String value2) {
            addCriterion("shipping_address between", value1, value2, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingAddressNotBetween(String value1, String value2) {
            addCriterion("shipping_address not between", value1, value2, "shippingAddress");
            return (Criteria) this;
        }

        public Criteria andShippingPersonIsNull() {
            addCriterion("shipping_person is null");
            return (Criteria) this;
        }

        public Criteria andShippingPersonIsNotNull() {
            addCriterion("shipping_person is not null");
            return (Criteria) this;
        }

        public Criteria andShippingPersonEqualTo(String value) {
            addCriterion("shipping_person =", value, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonNotEqualTo(String value) {
            addCriterion("shipping_person <>", value, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonGreaterThan(String value) {
            addCriterion("shipping_person >", value, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_person >=", value, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonLessThan(String value) {
            addCriterion("shipping_person <", value, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonLessThanOrEqualTo(String value) {
            addCriterion("shipping_person <=", value, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonLike(String value) {
            addCriterion("shipping_person like", value, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonNotLike(String value) {
            addCriterion("shipping_person not like", value, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonIn(List<String> values) {
            addCriterion("shipping_person in", values, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonNotIn(List<String> values) {
            addCriterion("shipping_person not in", values, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonBetween(String value1, String value2) {
            addCriterion("shipping_person between", value1, value2, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingPersonNotBetween(String value1, String value2) {
            addCriterion("shipping_person not between", value1, value2, "shippingPerson");
            return (Criteria) this;
        }

        public Criteria andShippingMobileIsNull() {
            addCriterion("shipping_mobile is null");
            return (Criteria) this;
        }

        public Criteria andShippingMobileIsNotNull() {
            addCriterion("shipping_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andShippingMobileEqualTo(String value) {
            addCriterion("shipping_mobile =", value, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileNotEqualTo(String value) {
            addCriterion("shipping_mobile <>", value, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileGreaterThan(String value) {
            addCriterion("shipping_mobile >", value, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_mobile >=", value, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileLessThan(String value) {
            addCriterion("shipping_mobile <", value, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileLessThanOrEqualTo(String value) {
            addCriterion("shipping_mobile <=", value, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileLike(String value) {
            addCriterion("shipping_mobile like", value, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileNotLike(String value) {
            addCriterion("shipping_mobile not like", value, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileIn(List<String> values) {
            addCriterion("shipping_mobile in", values, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileNotIn(List<String> values) {
            addCriterion("shipping_mobile not in", values, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileBetween(String value1, String value2) {
            addCriterion("shipping_mobile between", value1, value2, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingMobileNotBetween(String value1, String value2) {
            addCriterion("shipping_mobile not between", value1, value2, "shippingMobile");
            return (Criteria) this;
        }

        public Criteria andShippingPostIsNull() {
            addCriterion("shipping_post is null");
            return (Criteria) this;
        }

        public Criteria andShippingPostIsNotNull() {
            addCriterion("shipping_post is not null");
            return (Criteria) this;
        }

        public Criteria andShippingPostEqualTo(String value) {
            addCriterion("shipping_post =", value, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostNotEqualTo(String value) {
            addCriterion("shipping_post <>", value, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostGreaterThan(String value) {
            addCriterion("shipping_post >", value, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_post >=", value, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostLessThan(String value) {
            addCriterion("shipping_post <", value, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostLessThanOrEqualTo(String value) {
            addCriterion("shipping_post <=", value, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostLike(String value) {
            addCriterion("shipping_post like", value, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostNotLike(String value) {
            addCriterion("shipping_post not like", value, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostIn(List<String> values) {
            addCriterion("shipping_post in", values, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostNotIn(List<String> values) {
            addCriterion("shipping_post not in", values, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostBetween(String value1, String value2) {
            addCriterion("shipping_post between", value1, value2, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingPostNotBetween(String value1, String value2) {
            addCriterion("shipping_post not between", value1, value2, "shippingPost");
            return (Criteria) this;
        }

        public Criteria andShippingFeeIsNull() {
            addCriterion("shipping_fee is null");
            return (Criteria) this;
        }

        public Criteria andShippingFeeIsNotNull() {
            addCriterion("shipping_fee is not null");
            return (Criteria) this;
        }

        public Criteria andShippingFeeEqualTo(BigDecimal value) {
            addCriterion("shipping_fee =", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeNotEqualTo(BigDecimal value) {
            addCriterion("shipping_fee <>", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeGreaterThan(BigDecimal value) {
            addCriterion("shipping_fee >", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_fee >=", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeLessThan(BigDecimal value) {
            addCriterion("shipping_fee <", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_fee <=", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeIn(List<BigDecimal> values) {
            addCriterion("shipping_fee in", values, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeNotIn(List<BigDecimal> values) {
            addCriterion("shipping_fee not in", values, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_fee between", value1, value2, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_fee not between", value1, value2, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeIsNull() {
            addCriterion("receiver_time is null");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeIsNotNull() {
            addCriterion("receiver_time is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeEqualTo(Date value) {
            addCriterion("receiver_time =", value, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeNotEqualTo(Date value) {
            addCriterion("receiver_time <>", value, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeGreaterThan(Date value) {
            addCriterion("receiver_time >", value, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("receiver_time >=", value, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeLessThan(Date value) {
            addCriterion("receiver_time <", value, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeLessThanOrEqualTo(Date value) {
            addCriterion("receiver_time <=", value, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeIn(List<Date> values) {
            addCriterion("receiver_time in", values, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeNotIn(List<Date> values) {
            addCriterion("receiver_time not in", values, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeBetween(Date value1, Date value2) {
            addCriterion("receiver_time between", value1, value2, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andReceiverTimeNotBetween(Date value1, Date value2) {
            addCriterion("receiver_time not between", value1, value2, "receiverTime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNull() {
            addCriterion("created_by is null");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNotNull() {
            addCriterion("created_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedByEqualTo(String value) {
            addCriterion("created_by =", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotEqualTo(String value) {
            addCriterion("created_by <>", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThan(String value) {
            addCriterion("created_by >", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThanOrEqualTo(String value) {
            addCriterion("created_by >=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThan(String value) {
            addCriterion("created_by <", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThanOrEqualTo(String value) {
            addCriterion("created_by <=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLike(String value) {
            addCriterion("created_by like", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotLike(String value) {
            addCriterion("created_by not like", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByIn(List<String> values) {
            addCriterion("created_by in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotIn(List<String> values) {
            addCriterion("created_by not in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByBetween(String value1, String value2) {
            addCriterion("created_by between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotBetween(String value1, String value2) {
            addCriterion("created_by not between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIsNull() {
            addCriterion("created_time is null");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIsNotNull() {
            addCriterion("created_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeEqualTo(Date value) {
            addCriterion("created_time =", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotEqualTo(Date value) {
            addCriterion("created_time <>", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeGreaterThan(Date value) {
            addCriterion("created_time >", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("created_time >=", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeLessThan(Date value) {
            addCriterion("created_time <", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("created_time <=", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIn(List<Date> values) {
            addCriterion("created_time in", values, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotIn(List<Date> values) {
            addCriterion("created_time not in", values, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeBetween(Date value1, Date value2) {
            addCriterion("created_time between", value1, value2, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("created_time not between", value1, value2, "createdTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIsNull() {
            addCriterion("last_updated_by is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIsNotNull() {
            addCriterion("last_updated_by is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByEqualTo(String value) {
            addCriterion("last_updated_by =", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotEqualTo(String value) {
            addCriterion("last_updated_by <>", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByGreaterThan(String value) {
            addCriterion("last_updated_by >", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByGreaterThanOrEqualTo(String value) {
            addCriterion("last_updated_by >=", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLessThan(String value) {
            addCriterion("last_updated_by <", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLessThanOrEqualTo(String value) {
            addCriterion("last_updated_by <=", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLike(String value) {
            addCriterion("last_updated_by like", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotLike(String value) {
            addCriterion("last_updated_by not like", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIn(List<String> values) {
            addCriterion("last_updated_by in", values, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotIn(List<String> values) {
            addCriterion("last_updated_by not in", values, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByBetween(String value1, String value2) {
            addCriterion("last_updated_by between", value1, value2, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotBetween(String value1, String value2) {
            addCriterion("last_updated_by not between", value1, value2, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIsNull() {
            addCriterion("last_updated_time is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIsNotNull() {
            addCriterion("last_updated_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeEqualTo(Date value) {
            addCriterion("last_updated_time =", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotEqualTo(Date value) {
            addCriterion("last_updated_time <>", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeGreaterThan(Date value) {
            addCriterion("last_updated_time >", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_updated_time >=", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeLessThan(Date value) {
            addCriterion("last_updated_time <", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_updated_time <=", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIn(List<Date> values) {
            addCriterion("last_updated_time in", values, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotIn(List<Date> values) {
            addCriterion("last_updated_time not in", values, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeBetween(Date value1, Date value2) {
            addCriterion("last_updated_time between", value1, value2, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_updated_time not between", value1, value2, "lastUpdatedTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}